/ Software of the Month Club (Business) 1998 May / Software of the Month Club - Business Shareware (Volume 249) (May 1998).iso / dos / biz / inform-z / lesson25.pff

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 50 7e 46 20 46 6f 72 6d | 20 20 1a 6a 00 50 00 02 |P~F Form|  .j.P..|
|00000010| 00 f1 00 00 00 30 30 30 | 30 30 30 30 30 30 31 00 |.....000|0000001.|
|00000020| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000030| 20 20 20 20 20 20 20 20 | 00 00 00 00 00 00 00 00 |        |........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 42 4f 58 23 32 20 51 4e | 2a 24 4d 43 02 00 24 00 |BOX#2 QN|*$MC..$.|
|000000a0| 45 00 4e 00 00 00 00 00 | 00 00 00 00 24 00 34 00 |E.N.....|....$.4.|
|000000b0| 3b 00 24 00 3d 00 43 00 | 00 00 00 00 00 00 00 00 |;.$.=.C.|........|
|000000c0| 42 4f 58 23 32 20 51 4e | 2a 24 4d 43 02 00 26 00 |BOX#2 QN|*$MC..&.|
|000000d0| 45 00 4e 00 00 00 00 00 | 00 00 00 00 26 00 34 00 |E.N.....|....&.4.|
|000000e0| 3b 00 26 00 3d 00 43 00 | 00 00 00 00 00 00 00 00 |;.&.=.C.|........|
|000000f0| 20 da 1b 51 c4 bf 1b 36 | 20 da 1b 52 c4 c4 bf 0d | ..Q...6| ..R....|
|00000100| 0a 20 b3 20 20 55 73 69 | 6e 67 20 69 6e 66 6f 72 |. .  Usi|ng infor|
|00000110| 6d 2d 5a 1b 35 20 4c 65 | 73 73 6f 6e 20 20 32 35 |m-Z.5 Le|sson  25|
|00000120| 20 20 c3 1b 36 c4 b4 1b | 34 20 41 75 74 6f 6d 61 |  ..6...|4 Automa|
|00000130| 74 69 6e 67 20 46 6f 72 | 6d 73 3a 20 20 46 6f 72 |ting For|ms:  For|
|00000140| 6d 75 6c 61 73 1b 33 20 | 20 b3 0d 0a 20 c0 1b 51 |mulas.3 | ... ..Q|
|00000150| c4 d9 1b 36 20 c0 1b 52 | c4 c4 d9 0d 0a 0d 0a 1b |...6 ..R|........|
|00000160| 33 20 59 6f 75 20 74 72 | 79 20 69 74 21 20 20 41 |3 You tr|y it!  A|
|00000170| 64 64 20 74 77 6f 20 66 | 6f 72 6d 75 6c 61 73 20 |dd two f|ormulas |
|00000180| 74 6f 20 74 68 69 73 20 | 66 6f 72 6d 20 28 61 74 |to this |form (at|
|00000190| 20 22 31 22 20 61 6e 64 | 20 22 32 22 29 2e 0d 0a | "1" and| "2")...|
|000001a0| 0d 0a 1b 34 20 2a 20 4a | 75 73 74 20 6d 6f 76 65 |...4 * J|ust move|
|000001b0| 20 74 6f 20 74 68 65 20 | 66 69 72 73 74 20 22 20 | to the |first " |
|000001c0| 69 6e 20 22 31 22 20 61 | 6e 64 20 70 72 65 73 73 |in "1" a|nd press|
|000001d0| 20 63 74 72 6c 2d 46 31 | 2e 0d 0a 1b 34 20 2a 20 | ctrl-F1|....4 * |
|000001e0| 54 68 65 6e 20 66 6f 6c | 6c 6f 77 20 74 68 65 20 |Then fol|low the |
|000001f0| 70 72 6f 6d 70 74 73 20 | 61 74 20 74 68 65 20 62 |prompts |at the b|
|00000200| 6f 74 74 6f 6d 20 6f 66 | 20 79 6f 75 72 20 73 63 |ottom of| your sc|
|00000210| 72 65 65 6e 20 61 6e 64 | 20 74 68 65 20 64 69 61 |reen and| the dia|
|00000220| 6c 6f 67 20 62 6f 78 2e | 0d 0a 1b 34 20 2a 20 57 |log box.|...4 * W|
|00000230| 68 65 6e 20 79 6f 75 20 | 66 69 6e 69 73 68 20 61 |hen you |finish a|
|00000240| 64 64 69 6e 67 20 23 31 | 2c 20 6d 6f 76 65 20 74 |dding #1|, move t|
|00000250| 68 65 20 63 75 72 73 6f | 72 20 64 6f 77 6e 20 32 |he curso|r down 2|
|00000260| 20 72 6f 77 73 20 61 6e | 64 20 61 64 64 20 23 32 | rows an|d add #2|
|00000270| 2e 0d 0a 1b 34 20 2a 20 | 57 68 65 6e 20 79 6f 75 |....4 * |When you|
|00000280| 27 72 65 20 64 6f 6e 65 | 2c 20 70 72 65 73 73 20 |'re done|, press |
|00000290| 63 74 72 6c 2d 46 39 20 | 28 45 78 65 63 75 74 65 |ctrl-F9 |(Execute|
|000002a0| 20 66 6f 72 6d 75 6c 61 | 73 29 20 74 68 65 6e 20 | formula|s) then |
|000002b0| 61 6c 74 2d 55 20 28 55 | 6e 44 6f 29 2e 0d 0a 0d |alt-U (U|nDo)....|
|000002c0| 0a da 1b 3d c4 c2 1b 53 | c4 c2 1b 38 c4 c2 1b 37 |...=...S|...8...7|
|000002d0| c4 c2 1b 39 c4 c4 bf 0d | 0a b3 20 49 74 65 6d 20 |...9....|.. Item |
|000002e0| 4e 75 6d 62 65 72 20 b3 | 1b 3b 20 44 65 73 63 72 |Number .|.; Descr|
|000002f0| 69 70 74 69 6f 6e 1b 3d | 20 b3 51 75 61 6e 74 69 |iption.=| .Quanti|
|00000300| 74 79 b3 20 50 72 69 63 | 65 20 b3 20 20 54 6f 74 |ty. Pric|e .  Tot|
|00000310| 61 6c 1b 32 20 20 b3 0d | 0a c3 1b 3d c4 c5 1b 53 |al.2  ..|...=...S|
|00000320| c4 c5 1b 38 c4 c5 1b 37 | c4 c5 1b 39 c4 c4 b4 0d |...8...7|...9....|
|00000330| 0a b3 1b 35 20 31 32 33 | 1b 35 20 b3 20 42 6f 78 |...5 123|.5 . Box|
|00000340| 20 6f 66 20 31 30 20 20 | 35 20 31 2f 34 22 20 44 | of 10  |5 1/4" D|
|00000350| 44 20 46 6c 6f 70 70 79 | 20 44 69 73 6b 73 20 b3 |D Floppy| Disks .|
|00000360| 1b 33 20 34 32 1b 33 20 | b3 24 20 34 2e 39 39 20 |.3 42.3 |.$ 4.99 |
|00000370| b3 22 31 22 1b 36 20 20 | b3 0d 0a c3 1b 3d c4 c5 |."1".6  |.....=..|
|00000380| 1b 53 c4 c5 1b 38 c4 c5 | 1b 37 c4 c5 1b 39 c4 c4 |.S...8..|.7...9..|
|00000390| b4 0d 0a b3 1b 35 20 34 | 35 36 1b 35 20 b3 20 20 |.....5 4|56.5 .  |
|000003a0| 22 20 20 22 1b 33 20 22 | 20 20 33 20 31 2f 32 22 |"  ".3 "|  3 1/2"|
|000003b0| 20 44 44 1b 34 20 22 1b | 35 20 22 1b 33 20 b3 1b | DD.4 ".|5 ".3 ..|
|000003c0| 34 20 36 1b 33 20 b3 24 | 20 37 2e 39 39 20 b3 22 |4 6.3 .$| 7.99 ."|
|000003d0| 32 22 1b 36 20 20 b3 0d | 0a c0 1b 3d c4 c1 1b 53 |2".6  ..|...=...S|
|000003e0| c4 c1 1b 38 c4 c1 1b 33 | c4 c2 1b 33 c4 c1 1b 39 |...8...3|...3...9|
|000003f0| c4 c4 b4 0d 0a 1b 68 20 | 54 4f 54 41 4c 3a 20 b3 |......h |TOTAL: .|
|00000400| 20 20 22 33 22 1b 38 20 | 20 b3 0d 0a 1b 6f 20 c0 |  "3".8 | ....o .|
|00000410| 1b 3d c4 c4 d9 0d 0a 1b | 5f c4 b4 1b 34 20 50 72 |.=......|_...4 Pr|
|00000420| 65 73 73 20 50 67 44 6e | 20 6f 72 20 50 67 55 70 |ess PgDn| or PgUp|
|00000430| 20 2e 20 2e 20 2e 1b 32 | 20 20 b3 0d 0a 20 20 4e | . . ..2|  ...  N|
|00000440| 6f 77 20 61 64 64 20 74 | 68 65 20 6c 61 73 74 20 |ow add t|he last |
|00000450| 66 6f 72 6d 75 6c 61 20 | 61 74 20 22 33 22 20 62 |formula |at "3" b|
|00000460| 65 6c 6f 77 20 28 62 65 | 73 69 64 65 20 22 54 4f |elow (be|side "TO|
|00000470| 54 41 4c 3a 22 29 0d 0a | 0d 0a 1b 33 20 2a 20 4d |TAL:")..|...3 * M|
|00000480| 6f 76 65 20 74 6f 20 74 | 68 65 20 66 69 72 73 74 |ove to t|he first|
|00000490| 20 22 20 69 6e 20 22 33 | 22 20 61 6e 64 20 70 72 | " in "3|" and pr|
|000004a0| 65 73 73 20 63 74 72 6c | 2d 46 31 2e 20 20 4d 61 |ess ctrl|-F1.  Ma|
|000004b0| 72 6b 20 74 68 65 20 65 | 6e 74 69 72 65 20 62 6c |rk the e|ntire bl|
|000004c0| 61 6e 6b 0d 0a 1b 35 20 | 61 72 65 61 20 74 6f 20 |ank...5 |area to |
|000004d0| 74 68 65 20 72 69 67 68 | 74 2e 0d 0a 0d 0a 1b 33 |the righ|t......3|
|000004e0| 20 2a 20 41 74 20 74 68 | 65 20 64 69 61 6c 6f 67 | * At th|e dialog|
|000004f0| 20 62 6f 78 2c 20 73 65 | 6c 65 63 74 20 41 44 44 | box, se|lect ADD|
|00000500| 2c 20 43 55 52 52 45 4e | 43 59 20 61 6e 64 20 54 |, CURREN|CY and T|
|00000510| 57 4f 20 64 65 63 69 6d | 61 6c 20 70 6c 61 63 65 |WO decim|al place|
|00000520| 73 2e 0d 0a 0d 0a 1b 33 | 20 2a 20 4e 6f 77 20 6d |s......3| * Now m|
|00000530| 6f 76 65 20 74 6f 20 22 | 31 22 2c 20 70 72 65 73 |ove to "|1", pres|
|00000540| 73 20 3c 63 72 3e 20 74 | 6f 20 61 6e 63 68 6f 72 |s <cr> t|o anchor|
|00000550| 20 74 68 61 74 20 63 6f | 72 6e 65 72 2c 20 74 68 | that co|rner, th|
|00000560| 65 6e 20 65 78 70 61 6e | 64 20 74 68 65 20 72 75 |en expan|d the ru|
|00000570| 62 62 65 72 0d 0a 1b 35 | 20 62 61 6e 64 20 64 6f |bber...5| band do|
|00000580| 77 6e 20 32 20 6c 69 6e | 65 73 20 74 6f 20 63 6f |wn 2 lin|es to co|
|00000590| 76 65 72 20 74 68 65 20 | 45 4e 54 49 52 45 20 42 |ver the |ENTIRE B|
|000005a0| 4c 41 4e 4b 20 41 52 45 | 41 20 75 6e 64 65 72 20 |LANK ARE|A under |
|000005b0| 22 54 6f 74 61 6c 2e 22 | 0d 0a 0d 0a 20 20 46 69 |"Total."|....  Fi|
|000005c0| 6e 61 6c 6c 79 2c 20 70 | 72 65 73 73 20 63 74 72 |nally, p|ress ctr|
|000005d0| 6c 2d 46 39 20 28 45 78 | 65 63 75 74 65 20 66 6f |l-F9 (Ex|ecute fo|
|000005e0| 72 6d 75 6c 61 73 29 20 | 61 6e 64 20 61 64 6d 69 |rmulas) |and admi|
|000005f0| 72 65 20 79 6f 75 72 20 | 77 6f 72 6b 2e 0d 0a da |re your |work....|
|00000600| 1b 3d c4 c2 1b 53 c4 c2 | 1b 38 c4 c2 1b 37 c4 c2 |.=...S..|.8...7..|
|00000610| 1b 39 c4 c4 bf 0d 0a b3 | 20 49 74 65 6d 20 4e 75 |.9......| Item Nu|
|00000620| 6d 62 65 72 20 b3 1b 3b | 20 44 65 73 63 72 69 70 |mber ..;| Descrip|
|00000630| 74 69 6f 6e 1b 3d 20 b3 | 51 75 61 6e 74 69 74 79 |tion.= .|Quantity|
|00000640| b3 20 50 72 69 63 65 20 | b3 20 20 54 6f 74 61 6c |. Price |.  Total|
|00000650| 1b 32 20 20 b3 0d 0a c3 | 1b 3d c4 c5 1b 53 c4 c5 |.2  ....|.=...S..|
|00000660| 1b 38 c4 c5 1b 37 c4 c5 | 1b 39 c4 c4 b4 0d 0a b3 |.8...7..|.9......|
|00000670| 1b 35 20 31 32 33 1b 35 | 20 b3 20 42 6f 78 20 6f |.5 123.5| . Box o|
|00000680| 66 20 31 30 20 20 35 20 | 31 2f 34 22 20 44 44 20 |f 10  5 |1/4" DD |
|00000690| 46 6c 6f 70 70 79 20 44 | 69 73 6b 73 20 b3 1b 33 |Floppy D|isks ..3|
|000006a0| 20 34 32 1b 33 20 b3 24 | 20 34 2e 39 39 20 b3 22 | 42.3 .$| 4.99 ."|
|000006b0| 31 22 1b 36 20 20 b3 0d | 0a c3 1b 3d c4 c5 1b 53 |1".6  ..|...=...S|
|000006c0| c4 c5 1b 38 c4 c5 1b 37 | c4 c5 1b 39 c4 c4 b4 0d |...8...7|...9....|
|000006d0| 0a b3 1b 35 20 34 35 36 | 1b 35 20 b3 20 20 22 20 |...5 456|.5 .  " |
|000006e0| 20 22 1b 33 20 22 20 20 | 33 20 31 2f 32 22 20 44 | ".3 "  |3 1/2" D|
|000006f0| 44 1b 34 20 22 1b 35 20 | 22 1b 33 20 b3 1b 34 20 |D.4 ".5 |".3 ..4 |
|00000700| 36 1b 33 20 b3 24 20 37 | 2e 39 39 20 b3 22 32 22 |6.3 .$ 7|.99 ."2"|
|00000710| 1b 36 20 20 b3 0d 0a c0 | 1b 3d c4 c1 1b 53 c4 c1 |.6  ....|.=...S..|
|00000720| 1b 38 c4 c1 1b 33 c4 c2 | 1b 33 c4 c1 1b 39 c4 c4 |.8...3..|.3...9..|
|00000730| b4 0d 0a 1b 68 20 54 4f | 54 41 4c 3a 20 b3 20 20 |....h TO|TAL: .  |
|00000740| 22 33 22 1b 38 20 20 b3 | 0d 0a 1b 6f 20 c0 1b 3d |"3".8  .|...o ..=|
|00000750| c4 c4 d9 0d 0a 1b 5f c4 | b4 1b 34 20 50 72 65 73 |......_.|..4 Pres|
|00000760| 73 20 50 67 44 6e 20 6f | 72 20 50 67 55 70 20 2e |s PgDn o|r PgUp .|
|00000770| 20 2e 20 2e 1b 32 20 20 | b3 0d 0a 0d 0a 20 20 49 | . ..2  |.....  I|
|00000780| 4d 50 4f 52 54 41 4e 54 | 20 4e 4f 54 45 53 20 41 |MPORTANT| NOTES A|
|00000790| 62 6f 75 74 20 41 64 64 | 69 6e 67 20 46 6f 72 6d |bout Add|ing Form|
|000007a0| 75 6c 61 73 3a 0d 0a 0d | 0a 1b 33 20 2a 20 49 6e |ulas:...|..3 * In|
|000007b0| 20 74 68 65 20 6e 65 78 | 74 20 6c 65 73 73 6f 6e | the nex|t lesson|
|000007c0| 20 77 65 27 6c 6c 20 73 | 68 6f 77 20 79 6f 75 20 | we'll s|how you |
|000007d0| 68 6f 77 20 74 6f 20 45 | 44 49 54 20 66 6f 72 6d |how to E|DIT form|
|000007e0| 75 6c 61 73 2e 0d 0a 0d | 0a 1b 33 20 2a 20 57 68 |ulas....|..3 * Wh|
|000007f0| 65 6e 20 64 65 73 69 67 | 6e 69 6e 67 20 66 6f 72 |en desig|ning for|
|00000800| 6d 73 2c 20 70 6c 65 61 | 73 65 20 6d 61 6b 65 20 |ms, plea|se make |
|00000810| 61 64 64 69 6e 67 20 66 | 6f 72 6d 75 6c 61 73 20 |adding f|ormulas |
|00000820| 74 68 65 20 4c 41 53 54 | 20 74 68 69 6e 67 20 79 |the LAST| thing y|
|00000830| 6f 75 20 64 6f 2e 0d 0a | 1b 35 20 41 73 20 79 6f |ou do...|.5 As yo|
|00000840| 75 27 76 65 20 73 65 65 | 6e 2c 20 79 6f 75 20 63 |u've see|n, you c|
|00000850| 72 65 61 74 65 20 66 6f | 72 6d 75 6c 61 73 20 62 |reate fo|rmulas b|
|00000860| 79 20 73 69 6d 70 6c 79 | 20 6d 61 72 6b 69 6e 67 |y simply| marking|
|00000870| 20 61 72 65 61 73 20 6f | 66 20 79 6f 75 72 20 66 | areas o|f your f|
|00000880| 6f 72 6d 2e 0d 0a 1b 35 | 20 42 75 74 20 69 66 20 |orm....5| But if |
|00000890| 79 6f 75 20 61 64 64 20 | 66 6f 72 6d 75 6c 61 73 |you add |formulas|
|000008a0| 20 61 6e 64 20 74 68 65 | 6e 20 6d 6f 76 65 2c 20 | and the|n move, |
|000008b0| 69 6e 73 65 72 74 20 6f | 72 20 64 65 6c 65 74 65 |insert o|r delete|
|000008c0| 20 74 68 69 6e 67 73 2c | 20 74 68 65 20 61 72 65 | things,| the are|
|000008d0| 61 73 0d 0a 1b 35 20 79 | 6f 75 27 76 65 20 6d 61 |as...5 y|ou've ma|
|000008e0| 72 6b 65 64 20 6d 61 79 | 20 6e 6f 20 6c 6f 6e 67 |rked may| no long|
|000008f0| 65 72 20 62 65 20 77 68 | 65 72 65 20 79 6f 75 20 |er be wh|ere you |
|00000900| 73 61 69 64 20 74 68 65 | 79 27 64 20 62 65 2e 20 |said the|y'd be. |
|00000910| 20 45 64 69 74 69 6e 67 | 20 66 6f 72 6d 75 6c 61 | Editing| formula|
|00000920| 73 0d 0a 1b 35 20 63 61 | 6e 20 62 65 20 74 65 64 |s...5 ca|n be ted|
|00000930| 69 6f 75 73 2e 20 20 53 | 6f 20 6d 69 6e 69 6d 69 |ious.  S|o minimi|
|00000940| 7a 65 20 74 68 69 73 20 | 62 79 20 61 64 64 69 6e |ze this |by addin|
|00000950| 67 20 74 68 65 6d 20 77 | 68 65 6e 20 79 6f 75 72 |g them w|hen your|
|00000960| 20 66 6f 72 6d 27 73 20 | 64 6f 6e 65 21 0d 0a 0d | form's |done!...|
|00000970| 0a 1b 33 20 2a 20 4d 61 | 72 6b 20 52 65 73 75 6c |..3 * Ma|rk Resul|
|00000980| 74 73 20 43 65 6c 6c 73 | 20 63 61 72 65 66 75 6c |ts Cells| careful|
|00000990| 6c 79 2e 20 20 54 68 69 | 73 20 69 73 20 69 6d 70 |ly.  Thi|s is imp|
|000009a0| 6f 72 74 61 6e 74 20 66 | 6f 72 20 74 77 6f 20 72 |ortant f|or two r|
|000009b0| 65 61 73 6f 6e 73 3a 0d | 0a 1b 35 20 2d 20 54 6f |easons:.|..5 - To|
|000009c0| 20 65 6e 73 75 72 65 20 | 63 6f 6c 75 6d 6e 73 20 | ensure |columns |
|000009d0| 6c 69 6e 65 20 75 70 2c | 20 65 73 70 65 63 69 61 |line up,| especia|
|000009e0| 6c 6c 79 20 64 65 63 69 | 6d 61 6c 20 70 6f 69 6e |lly deci|mal poin|
|000009f0| 74 2e 20 20 48 65 72 65 | 2c 20 69 74 27 73 0d 0a |t.  Here|, it's..|
|00000a00| 1b 37 20 70 61 72 74 69 | 63 75 6c 61 72 6c 79 20 |.7 parti|cularly |
|00000a10| 69 6d 70 6f 72 74 61 6e | 74 20 74 6f 20 65 6e 73 |importan|t to ens|
|00000a20| 75 72 65 20 74 68 61 74 | 20 74 68 65 20 72 69 67 |ure that| the rig|
|00000a30| 68 74 20 65 64 67 65 20 | 6f 66 20 77 68 61 74 20 |ht edge |of what |
|00000a40| 79 6f 75 20 6d 61 72 6b | 0d 0a 1b 37 20 69 73 20 |you mark|...7 is |
|00000a50| 74 68 65 20 73 61 6d 65 | 20 66 6f 72 20 61 6c 6c |the same| for all|
|00000a60| 20 66 6f 72 6d 75 6c 61 | 73 20 69 6e 20 61 20 63 | formula|s in a c|
|00000a70| 6f 6c 75 6d 6e 2e 20 20 | 46 6f 72 20 74 68 69 73 |olumn.  |For this|
|00000a80| 20 72 65 61 73 6f 6e 2c | 20 79 6f 75 20 6d 69 67 | reason,| you mig|
|00000a90| 68 74 0d 0a 1b 37 20 77 | 61 6e 74 20 74 6f 20 6d |ht...7 w|ant to m|
|00000aa0| 61 72 6b 20 74 68 65 73 | 65 20 72 65 73 75 6c 74 |ark thes|e result|
|00000ab0| 73 20 63 65 6c 6c 73 20 | 66 72 6f 6d 20 52 69 67 |s cells |from Rig|
|00000ac0| 68 74 2d 74 6f 2d 4c 65 | 66 74 2e 0d 0a 1b 35 20 |ht-to-Le|ft....5 |
|00000ad0| 2d 20 54 6f 20 65 6e 73 | 75 72 65 20 74 68 61 74 |- To ens|ure that|
|00000ae0| 20 77 65 20 22 65 72 61 | 73 65 22 20 61 6e 79 20 | we "era|se" any |
|00000af0| 72 65 73 75 6c 74 73 20 | 74 68 61 74 20 6d 69 67 |results |that mig|
|00000b00| 68 74 20 62 65 20 6c 69 | 6e 67 65 72 69 6e 67 20 |ht be li|ngering |
|00000b10| 66 72 6f 6d 20 74 68 65 | 0d 0a 1b 37 20 6c 61 73 |from the|...7 las|
|00000b20| 74 20 74 69 6d 65 20 79 | 6f 75 20 70 72 65 73 73 |t time y|ou press|
|00000b30| 65 64 20 63 74 72 6c 2d | 46 39 20 28 45 78 65 63 |ed ctrl-|F9 (Exec|
|00000b40| 75 74 65 29 2e 20 20 57 | 68 65 6e 65 76 65 72 20 |ute).  W|henever |
|00000b50| 77 65 20 69 6e 73 65 72 | 74 20 72 65 73 75 6c 74 |we inser|t result|
|00000b60| 73 2c 0d 0a 1b 37 20 77 | 65 20 66 69 72 73 74 20 |s,...7 w|e first |
|00000b70| 65 72 61 73 65 20 74 68 | 65 20 61 72 65 61 20 2d |erase th|e area -|
|00000b80| 2d 20 74 6f 20 65 6e 73 | 75 72 65 20 70 72 69 6f |- to ens|ure prio|
|00000b90| 72 20 72 65 73 75 6c 74 | 73 20 61 72 65 20 65 72 |r result|s are er|
|00000ba0| 61 73 65 64 20 61 6e 64 | 20 79 6f 75 0d 0a 1b 37 |ased and| you...7|
|00000bb0| 20 64 6f 6e 27 74 20 65 | 6e 64 20 75 70 20 77 69 | don't e|nd up wi|
|00000bc0| 74 68 20 73 6f 6d 65 74 | 68 69 6e 67 20 6c 69 6b |th somet|hing lik|
|00000bd0| 65 3a 20 20 24 34 2c 24 | 31 39 2e 39 35 2e 0d 0a |e:  $4,$|19.95...|
|00000be0| 1b 5f c4 b4 1b 34 20 50 | 72 65 73 73 20 50 67 44 |._...4 P|ress PgD|
|00000bf0| 6e 20 6f 72 20 50 67 55 | 70 20 2e 20 2e 20 2e 1b |n or PgU|p . . ..|
|00000c00| 32 20 20 b3 0d 0a 0d 0a | 20 20 4d 4f 52 45 20 4e |2  .....|  MORE N|
|00000c10| 6f 74 65 73 20 41 62 6f | 75 74 20 41 64 64 69 6e |otes Abo|ut Addin|
|00000c20| 67 20 46 6f 72 6d 75 6c | 61 73 3a 0d 0a 0d 0a 1b |g Formul|as:.....|
|00000c30| 33 20 2a 20 59 6f 75 20 | 63 61 6e 20 63 72 65 61 |3 * You |can crea|
|00000c40| 74 65 20 66 6f 72 6d 75 | 6c 61 73 20 4f 4e 20 54 |te formu|las ON T|
|00000c50| 4f 50 20 4f 46 20 45 41 | 43 48 20 4f 54 48 45 52 |OP OF EA|CH OTHER|
|00000c60| 21 20 20 41 6e 64 20 74 | 68 65 72 65 27 73 20 6e |!  And t|here's n|
|00000c70| 6f 20 6c 69 6d 69 74 20 | 74 6f 0d 0a 1b 35 20 74 |o limit |to...5 t|
|00000c80| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 66 6f 72 |he numbe|r of for|
|00000c90| 6d 75 6c 61 73 20 79 6f | 75 20 63 61 6e 20 70 69 |mulas yo|u can pi|
|00000ca0| 6c 65 20 6f 6e 20 74 6f | 70 20 6f 66 20 65 61 63 |le on to|p of eac|
|00000cb0| 68 20 6f 74 68 65 72 2e | 0d 0a 1b 35 20 2d 20 45 |h other.|...5 - E|
|00000cc0| 61 63 68 20 6f 66 20 74 | 68 65 73 65 20 66 6f 72 |ach of t|hese for|
|00000cd0| 6d 75 6c 61 73 20 77 6f | 75 6c 64 20 68 61 76 65 |mulas wo|uld have|
|00000ce0| 20 74 68 65 20 73 61 6d | 65 20 52 65 73 75 6c 74 | the sam|e Result|
|00000cf0| 73 20 43 65 6c 6c 2e 20 | 20 49 6e 20 66 61 63 74 |s Cell. | In fact|
|00000d00| 2c 0d 0a 1b 37 20 73 6f | 6d 65 20 66 6f 72 6d 75 |,...7 so|me formu|
|00000d10| 6c 61 73 20 6d 69 67 68 | 74 20 75 73 65 20 74 68 |las migh|t use th|
|00000d20| 65 20 72 65 73 75 6c 74 | 73 20 6f 66 20 74 68 65 |e result|s of the|
|00000d30| 20 70 72 65 76 69 6f 75 | 73 20 66 6f 72 6d 75 6c | previou|s formul|
|00000d40| 61 73 2e 0d 0a 1b 35 20 | 2d 20 54 68 69 73 20 66 |as....5 |- This f|
|00000d50| 65 61 74 75 72 65 20 69 | 73 20 65 73 70 65 63 69 |eature i|s especi|
|00000d60| 61 6c 6c 79 20 75 73 65 | 66 75 6c 20 77 68 65 6e |ally use|ful when|
|00000d70| 20 61 20 66 6f 72 6d 75 | 6c 61 20 69 73 20 63 6f | a formu|la is co|
|00000d80| 6d 70 6c 65 78 2c 20 72 | 65 71 75 69 72 69 6e 67 |mplex, r|equiring|
|00000d90| 0d 0a 1b 37 20 73 65 76 | 65 72 61 6c 20 63 61 6c |...7 sev|eral cal|
|00000da0| 63 75 6c 61 74 69 6f 6e | 73 2e 20 20 46 6f 72 6d |culation|s.  Form|
|00000db0| 75 6c 61 73 20 32 2c 20 | 33 2c 20 65 74 63 2e 20 |ulas 2, |3, etc. |
|00000dc0| 75 73 65 20 65 61 72 6c | 69 65 72 20 72 65 73 75 |use earl|ier resu|
|00000dd0| 6c 74 73 20 74 6f 20 70 | 65 72 2d 0d 0a 1b 37 20 |lts to p|er-...7 |
|00000de0| 66 6f 72 6d 20 61 64 64 | 69 74 69 6f 6e 61 6c 20 |form add|itional |
|00000df0| 63 61 6c 63 75 6c 61 74 | 69 6f 6e 73 2e 20 20 59 |calculat|ions.  Y|
|00000e00| 6f 75 20 73 65 65 20 6f | 6e 6c 79 20 74 68 65 20 |ou see o|nly the |
|00000e10| 66 69 6e 61 6c 20 72 65 | 73 75 6c 74 73 2e 0d 0a |final re|sults...|
|00000e20| 0d 0a 1b 33 20 2a 20 59 | 6f 75 20 63 61 6e 20 41 |...3 * Y|ou can A|
|00000e30| 44 44 20 6e 75 6d 62 65 | 72 73 20 61 63 72 6f 73 |DD numbe|rs acros|
|00000e40| 73 20 72 6f 77 73 2c 20 | 64 6f 77 6e 20 63 6f 6c |s rows, |down col|
|00000e50| 75 6d 6e 73 2c 20 6f 72 | 20 62 6f 74 68 2e 20 20 |umns, or| both.  |
|00000e60| 49 6e 20 66 61 63 74 2c | 20 79 6f 75 20 63 61 6e |In fact,| you can|
|00000e70| 0d 0a 1b 35 20 61 64 64 | 20 75 70 20 73 65 76 65 |...5 add| up seve|
|00000e80| 72 61 6c 20 63 6f 6c 75 | 6d 6e 73 20 61 6e 64 20 |ral colu|mns and |
|00000e90| 72 6f 77 73 20 61 74 20 | 6f 6e 63 65 2c 20 6c 69 |rows at |once, li|
|00000ea0| 6b 65 20 77 68 65 6e 20 | 79 6f 75 20 6e 65 65 64 |ke when |you need|
|00000eb0| 20 61 20 47 52 41 4e 44 | 20 54 4f 54 41 4c 2e 0d | a GRAND| TOTAL..|
|00000ec0| 0a 1b 35 20 42 75 74 2c | 20 6e 75 6d 62 65 72 73 |..5 But,| numbers|
|00000ed0| 20 79 6f 75 20 61 64 64 | 20 6d 75 73 74 20 62 65 | you add| must be|
|00000ee0| 20 63 6f 6e 74 69 67 75 | 6f 75 73 2c 20 73 65 70 | contigu|ous, sep|
|00000ef0| 61 72 61 74 65 64 20 6f | 6e 6c 79 20 62 79 20 6c |arated o|nly by l|
|00000f00| 69 6e 65 73 20 6f 72 20 | 74 65 78 74 2e 0d 0a 0d |ines or |text....|
|00000f10| 0a 1b 33 20 2a 20 49 6e | 20 74 68 65 20 65 78 65 |..3 * In| the exe|
|00000f20| 72 63 69 73 65 73 20 61 | 62 6f 76 65 2c 20 79 6f |rcises a|bove, yo|
|00000f30| 75 20 6d 61 79 20 68 61 | 76 65 20 6e 6f 74 69 63 |u may ha|ve notic|
|00000f40| 65 73 20 77 65 20 65 6e | 63 6f 75 72 61 67 65 64 |es we en|couraged|
|00000f50| 20 79 6f 75 20 74 6f 20 | 22 6d 61 72 6b 22 0d 0a | you to |"mark"..|
|00000f60| 1b 35 20 6e 6f 6e 2d 6e | 75 6d 65 72 69 63 20 61 |.5 non-n|umeric a|
|00000f70| 72 65 61 73 20 6f 66 20 | 79 6f 75 72 20 66 6f 72 |reas of |your for|
|00000f80| 6d 3a 20 20 6c 69 6e 65 | 73 20 62 65 74 77 65 65 |m:  line|s betwee|
|00000f90| 6e 20 72 6f 77 73 2c 20 | 71 75 6f 74 61 74 69 6f |n rows, |quotatio|
|00000fa0| 6e 20 6d 61 72 6b 73 2c | 20 65 74 63 2e 0d 0a 1b |n marks,| etc....|
|00000fb0| 35 20 4e 6f 74 20 74 6f | 20 77 6f 72 72 79 2e 20 |5 Not to| worry. |
|00000fc0| 20 69 6e 66 6f 72 6d 2d | 5a 20 73 74 72 69 70 73 | inform-|Z strips|
|00000fd0| 20 6e 6f 6e 2d 6e 75 6d | 65 72 69 63 20 63 68 61 | non-num|eric cha|
|00000fe0| 72 61 63 74 65 72 73 20 | 62 65 66 6f 72 65 20 63 |racters |before c|
|00000ff0| 61 6c 63 75 6c 61 74 69 | 6e 67 2e 0d 0a 1b 35 20 |alculati|ng....5 |
|00001000| 49 6e 20 66 61 63 74 2c | 20 75 72 67 65 20 79 6f |In fact,| urge yo|
|00001010| 75 20 74 6f 20 6d 61 72 | 6b 20 22 61 20 6c 69 74 |u to mar|k "a lit|
|00001020| 74 6c 65 20 65 78 74 72 | 61 22 20 6f 6e 20 65 61 |tle extr|a" on ea|
|00001030| 63 68 20 73 69 64 65 20 | 6f 66 20 23 73 2e 20 20 |ch side |of #s.  |
|00001040| 54 68 69 73 0d 0a 1b 35 | 20 65 6e 73 75 72 65 73 |This...5| ensures|
|00001050| 20 74 68 61 74 20 69 66 | 20 79 6f 75 2c 20 73 61 | that if| you, sa|
|00001060| 79 2c 20 77 69 64 65 6e | 20 61 6e 20 41 2d 45 20 |y, widen| an A-E |
|00001070| 66 69 65 6c 64 2c 20 66 | 6f 72 6d 75 6c 61 73 20 |field, f|ormulas |
|00001080| 77 69 6c 6c 20 73 74 69 | 6c 6c 20 77 6f 72 6b 2e |will sti|ll work.|
|00001090| 0d 0a 0d 0a 1b 5f c4 b4 | 1b 34 20 50 72 65 73 73 |....._..|.4 Press|
|000010a0| 20 50 67 44 6e 20 6f 72 | 20 50 67 55 70 20 2e 20 | PgDn or| PgUp . |
|000010b0| 2e 20 2e 1b 32 20 20 b3 | 0d 0a 20 20 46 49 4e 41 |. ..2  .|..  FINA|
|000010c0| 4c 20 4e 6f 74 65 73 20 | 6f 6e 20 41 64 64 69 6e |L Notes |on Addin|
|000010d0| 67 20 46 6f 72 6d 75 6c | 61 73 3a 0d 0a 0d 0a 1b |g Formul|as:.....|
|000010e0| 33 20 2a 20 49 66 20 79 | 6f 75 20 61 64 64 20 66 |3 * If y|ou add f|
|000010f0| 6f 72 6d 75 6c 61 73 20 | 61 6e 64 20 74 68 65 6e |ormulas |and then|
|00001100| 20 49 6e 73 65 72 74 20 | 28 6f 72 20 44 65 6c 65 | Insert |(or Dele|
|00001110| 74 65 29 20 72 6f 77 73 | 20 6f 72 20 63 6f 6c 75 |te) rows| or colu|
|00001120| 6d 6e 73 2c 20 69 6e 66 | 6f 72 6d 2d 5a 0d 0a 1b |mns, inf|orm-Z...|
|00001130| 35 20 61 75 74 6f 6d 61 | 74 69 63 61 6c 6c 79 20 |5 automa|tically |
|00001140| 61 64 6a 75 73 74 73 20 | 74 68 65 20 66 6f 72 6d |adjusts |the form|
|00001150| 75 6c 61 73 20 66 6f 72 | 20 79 6f 75 2e 0d 0a 1b |ulas for| you....|
|00001160| 35 20 2d 20 54 68 69 73 | 20 65 6e 73 75 72 65 73 |5 - This| ensures|
|00001170| 20 74 68 61 74 20 72 65 | 73 75 6c 74 73 20 70 72 | that re|sults pr|
|00001180| 69 6e 74 20 77 68 65 72 | 65 20 79 6f 75 20 65 78 |int wher|e you ex|
|00001190| 70 65 63 74 20 74 68 65 | 6d 20 74 6f 2c 20 61 6e |pect the|m to, an|
|000011a0| 64 20 74 68 61 74 20 77 | 65 0d 0a 1b 37 20 75 73 |d that w|e...7 us|
|000011b0| 65 20 74 68 65 20 61 70 | 70 72 6f 70 72 69 61 74 |e the ap|propriat|
|000011c0| 65 20 61 72 65 61 73 20 | 6f 66 20 79 6f 75 72 20 |e areas |of your |
|000011d0| 66 6f 72 6d 20 74 6f 20 | 67 65 74 20 74 68 65 20 |form to |get the |
|000011e0| 6e 75 6d 62 65 72 73 2e | 0d 0a 1b 35 20 2d 20 54 |numbers.|...5 - T|
|000011f0| 68 69 73 20 66 65 61 74 | 75 72 65 20 77 6f 72 6b |his feat|ure work|
|00001200| 73 20 4f 4e 4c 59 20 69 | 66 20 79 6f 75 20 75 73 |s ONLY i|f you us|
|00001210| 65 20 61 6c 74 2d 49 2f | 63 74 72 6c 2d 49 20 74 |e alt-I/|ctrl-I t|
|00001220| 6f 20 69 6e 73 65 72 74 | 2c 20 6f 72 0d 0a 1b 37 |o insert|, or...7|
|00001230| 20 61 6c 74 2d 58 2f 63 | 74 72 6c 2d 58 20 74 6f | alt-X/c|trl-X to|
|00001240| 20 64 65 6c 65 74 65 20 | 72 6f 77 73 20 6f 72 20 | delete |rows or |
|00001250| 63 6f 6c 75 6d 6e 73 2c | 20 72 65 73 70 65 63 74 |columns,| respect|
|00001260| 69 76 65 6c 79 2e 0d 0a | 0d 0a 1b 33 20 2a 20 50 |ively...|...3 * P|
|00001270| 72 65 73 73 20 61 6c 74 | 2d 4f 20 28 4f 70 74 69 |ress alt|-O (Opti|
|00001280| 6f 6e 73 29 20 74 6f 20 | 73 65 6c 65 63 74 20 74 |ons) to |select t|
|00001290| 77 6f 20 74 68 69 6e 67 | 73 20 77 68 69 63 68 20 |wo thing|s which |
|000012a0| 61 66 66 65 63 74 20 68 | 6f 77 20 72 65 73 75 6c |affect h|ow resul|
|000012b0| 74 73 20 70 72 69 6e 74 | 2e 0d 0a 0d 0a 1b 35 20 |ts print|......5 |
|000012c0| 5b 58 5d 20 53 75 70 70 | 72 65 73 73 20 27 63 61 |[X] Supp|ress 'ca|
|000012d0| 6c 63 75 6c 61 74 65 64 | 20 7a 65 72 6f 73 27 20 |lculated| zeros' |
|000012e0| 69 6e 20 66 6f 72 6d 75 | 6c 61 73 0d 0a 1b 39 20 |in formu|las...9 |
|000012f0| 2d 20 53 65 6c 65 63 74 | 20 74 68 69 73 20 74 6f |- Select| this to|
|00001300| 20 65 6e 73 75 72 65 20 | 74 68 61 74 20 69 6e 2c | ensure |that in,|
|00001310| 20 73 61 79 2c 20 6f 72 | 64 65 72 20 66 6f 72 6d | say, or|der form|
|00001320| 73 20 6f 72 20 69 6e 76 | 6f 69 63 65 73 2c 20 69 |s or inv|oices, i|
|00001330| 66 20 73 6f 6d 65 0d 0a | 1b 3b 20 74 68 69 6e 67 |f some..|.; thing|
|00001340| 73 20 61 72 65 20 4e 4f | 54 20 6f 72 64 65 72 65 |s are NO|T ordere|
|00001350| 64 2c 20 77 65 20 64 6f | 20 4e 4f 54 20 70 72 69 |d, we do| NOT pri|
|00001360| 6e 74 20 22 24 30 2e 30 | 30 22 20 28 77 65 20 6c |nt "$0.0|0" (we l|
|00001370| 65 61 76 65 20 69 74 20 | 62 6c 61 6e 6b 29 2e 0d |eave it |blank)..|
|00001380| 0a 1b 35 20 5b 58 5d 20 | 49 6e 63 6c 75 64 65 20 |..5 [X] |Include |
|00001390| 27 74 68 6f 75 73 61 6e | 64 73 20 73 65 70 61 72 |'thousan|ds separ|
|000013a0| 61 74 6f 72 27 20 69 6e | 20 66 6f 72 6d 75 6c 61 |ator' in| formula|
|000013b0| 73 0d 0a 1b 39 20 2d 20 | 53 65 6c 65 63 74 20 74 |s...9 - |Select t|
|000013c0| 68 69 73 20 74 6f 20 73 | 65 70 61 72 61 74 65 20 |his to s|eparate |
|000013d0| 22 74 68 6f 75 73 61 6e | 64 73 22 20 77 69 74 68 |"thousan|ds" with|
|000013e0| 20 63 6f 6d 6d 61 73 20 | 28 65 67 2e 2c 20 20 24 | commas |(eg.,  $|
|000013f0| 20 32 2c 33 39 39 2e 39 | 39 29 2e 0d 0a 0d 0a 1b | 2,399.9|9)......|
|00001400| 33 20 2a 20 53 45 43 52 | 45 54 20 54 49 50 3a 20 |3 * SECR|ET TIP: |
|00001410| 20 59 6f 75 20 63 61 6e | 20 63 72 65 61 74 65 20 | You can| create |
|00001420| 22 73 65 6c 66 2d 65 72 | 61 73 69 6e 67 22 20 66 |"self-er|asing" f|
|00001430| 6f 72 6d 75 6c 61 73 2e | 20 20 54 68 69 73 20 69 |ormulas.|  This i|
|00001440| 73 20 75 73 65 66 75 6c | 20 77 68 65 6e 0d 0a 1b |s useful| when...|
|00001450| 35 20 79 6f 75 20 6e 65 | 65 64 20 61 6e 20 22 69 |5 you ne|ed an "i|
|00001460| 6e 74 65 72 6d 65 64 69 | 61 74 65 20 77 6f 72 6b |ntermedi|ate work|
|00001470| 20 61 72 65 61 2e 22 20 | 20 4a 75 73 74 20 41 44 | area." | Just AD|
|00001480| 44 20 61 20 62 6c 61 6e | 6b 20 61 72 65 61 20 74 |D a blan|k area t|
|00001490| 6f 20 74 68 69 73 20 72 | 65 67 69 6f 6e 0d 0a 1b |o this r|egion...|
|000014a0| 35 20 61 73 20 79 6f 75 | 72 20 6c 61 73 74 20 66 |5 as you|r last f|
|000014b0| 6f 72 6d 75 6c 61 21 20 | 20 54 68 69 73 20 4f 4e |ormula! | This ON|
|000014c0| 4c 59 20 57 4f 52 4b 53 | 20 69 66 20 22 53 75 70 |LY WORKS| if "Sup|
|000014d0| 70 72 65 73 73 20 5a 65 | 72 6f 73 22 20 69 73 20 |press Ze|ros" is |
|000014e0| 4f 4e 2e 0d 0a 1b 49 c4 | b4 20 54 68 61 74 27 73 |ON....I.|. That's|
|000014f0| 20 61 6c 6c 20 68 65 72 | 65 2e 20 20 50 72 65 73 | all her|e.  Pres|
|00001500| 73 20 46 34 20 61 6e 64 | 20 6c 6f 61 64 20 74 68 |s F4 and| load th|
|00001510| 65 20 6e 65 78 74 20 6c | 65 73 73 6f 6e 2e b3 0d |e next l|esson...|
|00001520| 0a                      |                         |.       |        |
+--------+-------------------------+-------------------------+--------+--------+